QCC Data Warehouse

July 11, 2018

What’s the value add of the data warehouse?

  • Effective dating

  • Snapshots

  • Automation

  • User friendly interface

Effective Dating

  • But CUNY First has effective dates

  • Confused

Effective Dating

  • Many CUNY First tables don’t have effective dates

  • Almost no tables have effective end dates

  • Data warehouse creates end dates for effective dated fields

  • Data warehouse creates effective dates and effective end dates for fields without

Snapshots

TimeTravel

Snapshots

  • Historical static views of CUNY First at specified points in history

    • Census date
    • First day of term
    • Current offset
    • Etc.

Automation

robot

Automation

  • IT has this all set up automatically

  • The reporting instance query

  • Extraction from tumbleweed

  • The effective dating

  • The snapshots

User Interface

  • OBIEE web app interface

  • Abstracts away leftover complexity of datawarehouse

  • No SQL required

  • Drag and drop gui